Summary

This reflects an analysis of the DAP Cancer Events dataset. This dataset contains 938 rows (one row per hospital), and 12 attributes for each hospital.

We’ve conducted the following analysis for each attribute
- defined descriptive statistics
- histogram
- scatterplot of data by hospital
- scatterplot of data by state
- map data

In addition, we’ve run a correlation analysis and then a linear regression model for all correlations greater than |0.5|

Analysis

Column

Deaths

Chart 1

[1] "Mean: 145.265458422175"
[1] "Median: 125"
[1] "Standard Deviation: 69.6487827302734"
[1] "Skewness: 2.66519410583897"
[1] "Kurtosis: 14.3827129459792"

Chart 2

Chart 3

Chart 4

% Died in Hospital

Chart 1

[1] "Mean: 30.4624060150376"
[1] "Median: 29.9"
[1] "Standard Deviation: 8.34713937287759"
[1] "Skewness: 0.402845575498664"
[1] "Kurtosis: 3.10253344355045"

Chart 2

Chart 3

Chart 4

% Admitted Last Month of Life

Chart 1

[1] "Mean: 64.3534115138593"
[1] "Median: 64.2"
[1] "Standard Deviation: 5.77795963912996"
[1] "Skewness: 0.0179014763249724"
[1] "Kurtosis: 3.3297094632259"

Chart 2

Chart 3

Chart 4

Hospital Days Last Month of Life

Chart 1

[1] "Mean: 5.74456289978678"
[1] "Median: 5.7"
[1] "Standard Deviation: 0.976914572494382"
[1] "Skewness: 0.295076647718844"
[1] "Kurtosis: 3.21604510459635"

Chart 2

Chart 3

Chart 4

% Admitted to ICU Last Month of Life

Chart 1

[1] "Mean: 25.6288209606987"
[1] "Median: 24.4"
[1] "Standard Deviation: 9.36851949431984"
[1] "Skewness: 0.688880827493528"
[1] "Kurtosis: 3.28072116787985"

Chart 2

Chart 3

Chart 4

ICU Days Last Month of Life

Chart 1

[1] "Mean: 1.28296943231441"
[1] "Median: 1.2"
[1] "Standard Deviation: 0.768060735263603"
[1] "Skewness: 1.20461150307298"
[1] "Kurtosis: 5.19943195537825"

Chart 2

Chart 3

Chart 4

% receiving life sustaining treatment last month of life

Chart 1

[1] "Mean: 11.7425454545455"
[1] "Median: 11.05"
[1] "Standard Deviation: 3.69081576530349"
[1] "Skewness: 0.951478671995582"
[1] "Kurtosis: 4.34101308834186"

Chart 2

Chart 3

Chart 4

% receiving chemotherapy last 2 weeks of life

Chart 1

[1] "Mean: 9.26740506329114"
[1] "Median: 8.7"
[1] "Standard Deviation: 3.42036583588304"
[1] "Skewness: 1.24624891446332"
[1] "Kurtosis: 5.42097748862664"

Chart 2

Chart 3

Chart 4

% Hospice last month of life

Chart 1

[1] "Mean: 55.3044823906083"
[1] "Median: 55.6"
[1] "Standard Deviation: 11.8151910932693"
[1] "Skewness: -0.256722433992258"
[1] "Kurtosis: 3.06274209474661"

Chart 2

Chart 3

Chart 4

Hospice Days Last Month of Life

Chart 1

[1] "Mean: 8.5769477054429"
[1] "Median: 8.6"
[1] "Standard Deviation: 2.10675604079465"
[1] "Skewness: -0.00447642610845523"
[1] "Kurtosis: 2.94785597006637"

Chart 2

Chart 3

Chart 4

% Hospice Last 3 Days of Life

Chart 1

[1] "Mean: 11.4885480572597"
[1] "Median: 11.2"
[1] "Standard Deviation: 3.79923845613285"
[1] "Skewness: 0.718609957588257"
[1] "Kurtosis: 4.01274240765306"

Chart 2

Chart 3

Chart 4

% saw more than 10 physicians last 6 months of life

Chart 1

[1] "Mean: 52.5716417910448"
[1] "Median: 52.9"
[1] "Standard Deviation: 12.6358211514082"
[1] "Skewness: -0.171086564547256"
[1] "Kurtosis: 2.62866589106455"

Chart 2

Chart 3

Chart 4

Correlation

Linear Regression

Row

predicting % hospice last month given % died in hospital

[1] "Adjusted r squared= 0.671665988785723"

predicting % died in hospital given number of hospice days last month

[1] "Adjusted r squared= 0.46276897726445"

predicting hospital days last month given % admitted last month

[1] "Adjusted r squared= 0.372540202579385"

predicting hospice days last month given % admitted last month

[1] "Adjusted r squared= 0.3401133870442"

predicting ICU days last month given % admitted ICU last month

[1] "Adjusted r squared= 0.832034215365293"

predicting hospice days last month given % hospice last month

[1] "Adjusted r squared= 0.680732429100812"

predicting % hospice last 3 days given % hospice last month

[1] "Adjusted r squared= 0.273557274772961"

predicting % died in hospital given hospital, hospice days and percentage hospice days last month

[1] "Adjusted r squared= 0.768643570928753"

predicting % died in hospital given state

[1] "Adjusted r squared= 0.310262953108519"

predicting % died in hospital given city

[1] "Adjusted r squared= 0.439734378478089"

predicting % died in hospital given city and state

[1] "Adjusted r squared= 0.518439483147694"

Linear Models

Column

Plot LM 1

Plot LM 2

Plot LM 3

Plot LM 4

Plot LM 5

Plot LM 6

Plot LM 7